SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 44823: When PROC TRANTAB is submitted via SAS® Enterprise Guide, an error occurs

DetailsAboutRate It

The TRANTAB procedure creates a translation table in the profile.sas7bcat catalog in your SASUSER data library. If the profile catalog cannot be opened for write access, you will receive an error similar to the following:

   ERROR: Cannot open entry xxxxx.TRANTAB for write access - catalog
          SASUSER.PROFILE is opened for read access.

When you invoke a SAS® Enterprise Guide session, the options in the Lev1/SASApp/sasv9.cfg file are in effect for your session. One of the options in that file is RSASUSER. The RSASUSER option causes the SASUSER data library to be opened in read-only mode, so the TRANTAB table cannot be written to the profile.sas7bcat catalog.

It is not possible to create the translation table in a different directory.
To solve the problem, ask your SAS administrator or your UNIX system administrator to set the -NORSASUSER option as a restricted option for the userid that is used to create translation tables. The method for setting a restricted option is documented in Chapter 2 of the Configuration Guide for SAS® 9.2 Foundation for UNIX® Environments.

Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SAS64-bit Enabled AIX9.1 TS1M3 SP49.4 TS1M0
64-bit Enabled HP-UX9.1 TS1M3 SP49.4 TS1M0
64-bit Enabled Solaris9.1 TS1M3 SP49.4 TS1M0
HP-UX IPF9.1 TS1M3 SP49.4 TS1M0
Linux9.1 TS1M3 SP49.4 TS1M0
Linux on Itanium9.1 TS1M3 SP49.4 TS1M0
Solaris for x649.1 TS1M3 SP49.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.